package com.fan.dao.provider;

import com.fan.pojo.Provider;
import com.fan.pojo.User;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface ProviderDao {
    public int getProviderCount(Connection connection,String proCode,String proName) throws SQLException;
    public List<Provider> getProviderList(Connection connection, String proCode, String proName, int currentPageNo, int pageSize) throws SQLException;
    public List<Provider> getProviderList(Connection connection) throws SQLException;
    public int addProvider(Connection connection, Provider provider) throws SQLException;
    public int deleteProviderById(Connection connection, Integer delId) throws SQLException;
    public Provider getProviderById(Connection connection, String id) throws SQLException;
    public boolean updateProviderById(Connection connection, String id, String proCode, String proName, String proDesc, String proContact, String proPhone, String proAddress, String proFax) throws SQLException;
}
